Dataset statistics
| Number of variables | 11 |
|---|---|
| Number of observations | 329237 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 27.6 MiB |
| Average record size in memory | 88.0 B |
Variable types
| NUM | 11 |
|---|
Reproduction
| Analysis started | 2020-08-25 23:38:41.004779 |
|---|---|
| Analysis finished | 2020-08-25 23:40:31.973569 |
| Duration | 1 minute and 50.97 seconds |
| Version | pandas-profiling v2.8.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
year
Real number (ℝ≥0)
| Distinct count | 29 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2002.0 |
|---|---|
| Minimum | 1988 |
| Maximum | 2016 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 1988 |
|---|---|
| 5-th percentile | 1989 |
| Q1 | 1995 |
| median | 2002 |
| Q3 | 2009 |
| 95-th percentile | 2015 |
| Maximum | 2016 |
| Range | 28 |
| Interquartile range (IQR) | 14 |
Descriptive statistics
| Standard deviation | 8.366612971 |
|---|---|
| Coefficient of variation (CV) | 0.004179127358 |
| Kurtosis | -1.202857186 |
| Mean | 2002 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 0 |
| Sum | 659132474 |
| Variance | 70.00021261 |
| Value | Count | Frequency (%) | |
| 2016 | 11353 | 3.4% | |
| 2001 | 11353 | 3.4% | |
| 1989 | 11353 | 3.4% | |
| 1990 | 11353 | 3.4% | |
| 1991 | 11353 | 3.4% | |
| 1992 | 11353 | 3.4% | |
| 1993 | 11353 | 3.4% | |
| 1994 | 11353 | 3.4% | |
| 1995 | 11353 | 3.4% | |
| 1996 | 11353 | 3.4% | |
| Other values (19) | 215707 | 65.5% |
| Value | Count | Frequency (%) | |
| 1988 | 11353 | 3.4% | |
| 1989 | 11353 | 3.4% | |
| 1990 | 11353 | 3.4% | |
| 1991 | 11353 | 3.4% | |
| 1992 | 11353 | 3.4% |
| Value | Count | Frequency (%) | |
| 2016 | 11353 | 3.4% | |
| 2015 | 11353 | 3.4% | |
| 2014 | 11353 | 3.4% | |
| 2013 | 11353 | 3.4% | |
| 2012 | 11353 | 3.4% |
zipcode
Real number (ℝ≥0)
| Distinct count | 11353 |
|---|---|
| Unique (%) | 3.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 45295.89747203382 |
|---|---|
| Minimum | 1001 |
| Maximum | 99901 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 1001 |
|---|---|
| 5-th percentile | 6001 |
| Q1 | 19425 |
| median | 39475 |
| Q3 | 72370 |
| 95-th percentile | 95811 |
| Maximum | 99901 |
| Range | 98900 |
| Interquartile range (IQR) | 52945 |
Descriptive statistics
| Standard deviation | 29526.88225 |
|---|---|
| Coefficient of variation (CV) | 0.6518665905 |
| Kurtosis | -1.154559594 |
| Mean | 45295.89747 |
| Median Absolute Deviation (MAD) | 24662 |
| Skewness | 0.3152461507 |
| Sum | 1.49130854e+10 |
| Variance | 871836775.4 |
| Value | Count | Frequency (%) | |
| 28658 | 29 | < 0.1% | |
| 70775 | 29 | < 0.1% | |
| 32837 | 29 | < 0.1% | |
| 45123 | 29 | < 0.1% | |
| 47170 | 29 | < 0.1% | |
| 92024 | 29 | < 0.1% | |
| 32603 | 29 | < 0.1% | |
| 30554 | 29 | < 0.1% | |
| 26456 | 29 | < 0.1% | |
| 1876 | 29 | < 0.1% | |
| Other values (11343) | 328947 | 99.9% |
| Value | Count | Frequency (%) | |
| 1001 | 29 | < 0.1% | |
| 1002 | 29 | < 0.1% | |
| 1005 | 29 | < 0.1% | |
| 1007 | 29 | < 0.1% | |
| 1010 | 29 | < 0.1% |
| Value | Count | Frequency (%) | |
| 99901 | 29 | < 0.1% | |
| 99801 | 29 | < 0.1% | |
| 99709 | 29 | < 0.1% | |
| 99701 | 29 | < 0.1% | |
| 99577 | 29 | < 0.1% |
EQI_zip
Real number (ℝ≥0)
| Distinct count | 322573 |
|---|---|
| Unique (%) | 98.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.0005261158443904059 |
|---|---|
| Minimum | 1.1998789e-05 |
| Maximum | 0.0641894 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 1.1998789e-05 |
|---|---|
| 5-th percentile | 0.000116825016 |
| Q1 | 0.00021236634 |
| median | 0.00032423303 |
| Q3 | 0.00052009925 |
| 95-th percentile | 0.00138488888 |
| Maximum | 0.0641894 |
| Range | 0.06417740121 |
| Interquartile range (IQR) | 0.00030773291 |
Descriptive statistics
| Standard deviation | 0.000996061107 |
|---|---|
| Coefficient of variation (CV) | 1.893235335 |
| Kurtosis | 457.1446999 |
| Mean | 0.0005261158444 |
| Median Absolute Deviation (MAD) | 0.00013423315 |
| Skewness | 15.37889315 |
| Sum | 173.2168023 |
| Variance | 9.921377288e-07 |
| Value | Count | Frequency (%) | |
| 0.0004910004 | 58 | < 0.1% | |
| 0.0011926616 | 46 | < 0.1% | |
| 0.00023086638 | 46 | < 0.1% | |
| 0.0003055213 | 44 | < 0.1% | |
| 0.0016380961 | 42 | < 0.1% | |
| 0.0006648359 | 41 | < 0.1% | |
| 0.00022039752 | 39 | < 0.1% | |
| 0.0006497198 | 36 | < 0.1% | |
| 0.00073148106 | 32 | < 0.1% | |
| 0.0001871098 | 31 | < 0.1% | |
| Other values (322563) | 328822 | 99.9% |
| Value | Count | Frequency (%) | |
| 1.1998789e-05 | 1 | < 0.1% | |
| 1.3727406e-05 | 1 | < 0.1% | |
| 1.4215268e-05 | 1 | < 0.1% | |
| 1.4599402e-05 | 1 | < 0.1% | |
| 1.4817676e-05 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0.0641894 | 1 | < 0.1% | |
| 0.057795137 | 1 | < 0.1% | |
| 0.05652261 | 1 | < 0.1% | |
| 0.05462911 | 1 | < 0.1% | |
| 0.0515555 | 1 | < 0.1% |
SFR_zip
Real number (ℝ≥0)
| Distinct count | 1528 |
|---|---|
| Unique (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 85.59444108651215 |
|---|---|
| Minimum | 1.0 |
| Maximum | 6883.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 14 |
| median | 38 |
| Q3 | 100 |
| 95-th percentile | 320 |
| Maximum | 6883 |
| Range | 6882 |
| Interquartile range (IQR) | 86 |
Descriptive statistics
| Standard deviation | 137.9164631 |
|---|---|
| Coefficient of variation (CV) | 1.611278272 |
| Kurtosis | 81.24951283 |
| Mean | 85.59444109 |
| Median Absolute Deviation (MAD) | 29 |
| Skewness | 5.728550577 |
| Sum | 28180857 |
| Variance | 19020.9508 |
| Value | Count | Frequency (%) | |
| 5 | 6979 | 2.1% | |
| 6 | 6943 | 2.1% | |
| 7 | 6915 | 2.1% | |
| 8 | 6815 | 2.1% | |
| 4 | 6556 | 2.0% | |
| 9 | 6510 | 2.0% | |
| 10 | 6427 | 2.0% | |
| 3 | 6146 | 1.9% | |
| 11 | 5962 | 1.8% | |
| 12 | 5723 | 1.7% | |
| Other values (1518) | 264261 | 80.3% |
| Value | Count | Frequency (%) | |
| 1 | 3341 | 1.0% | |
| 2 | 5085 | 1.5% | |
| 3 | 6146 | 1.9% | |
| 4 | 6556 | 2.0% | |
| 5 | 6979 | 2.1% |
| Value | Count | Frequency (%) | |
| 6883 | 1 | < 0.1% | |
| 5858 | 1 | < 0.1% | |
| 4307 | 1 | < 0.1% | |
| 4201 | 1 | < 0.1% | |
| 4103 | 1 | < 0.1% |
RECPI_zip
Real number (ℝ≥0)
| Distinct count | 323968 |
|---|---|
| Unique (%) | 98.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.04431950449455612 |
|---|---|
| Minimum | 1.1998789e-05 |
| Maximum | 9.541773 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 1.1998789e-05 |
|---|---|
| 5-th percentile | 0.00099471418 |
| Q1 | 0.0042709424 |
| median | 0.013481382 |
| Q3 | 0.038867597 |
| 95-th percentile | 0.164759802 |
| Maximum | 9.541773 |
| Range | 9.541761001 |
| Interquartile range (IQR) | 0.0345966546 |
Descriptive statistics
| Standard deviation | 0.1388480899 |
|---|---|
| Coefficient of variation (CV) | 3.132889041 |
| Kurtosis | 612.761959 |
| Mean | 0.04431950449 |
| Median Absolute Deviation (MAD) | 0.011116123 |
| Skewness | 18.2065209 |
| Sum | 14591.6207 |
| Variance | 0.01927879208 |
| Value | Count | Frequency (%) | |
| 0.0004910004 | 42 | < 0.1% | |
| 0.0003055213 | 35 | < 0.1% | |
| 0.00023086638 | 35 | < 0.1% | |
| 0.0011926616 | 34 | < 0.1% | |
| 0.0006648359 | 32 | < 0.1% | |
| 0.0016380961 | 32 | < 0.1% | |
| 0.00022039752 | 31 | < 0.1% | |
| 0.0006497198 | 23 | < 0.1% | |
| 0.0001871098 | 23 | < 0.1% | |
| 0.00073148106 | 22 | < 0.1% | |
| Other values (323958) | 328928 | 99.9% |
| Value | Count | Frequency (%) | |
| 1.1998789e-05 | 1 | < 0.1% | |
| 1.3727406e-05 | 1 | < 0.1% | |
| 1.4817676e-05 | 1 | < 0.1% | |
| 1.8027562e-05 | 1 | < 0.1% | |
| 1.8461504e-05 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 9.541773 | 1 | < 0.1% | |
| 9.173729 | 1 | < 0.1% | |
| 8.419393 | 1 | < 0.1% | |
| 7.458536 | 1 | < 0.1% | |
| 7.4182096 | 1 | < 0.1% |
EQI_MSA
Real number (ℝ≥0)
| Distinct count | 21457 |
|---|---|
| Unique (%) | 6.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.0005672011306991286 |
|---|---|
| Minimum | 2.37131e-05 |
| Maximum | 0.015639344 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 2.37131e-05 |
|---|---|
| 5-th percentile | 0.00014551292 |
| Q1 | 0.00025281747 |
| median | 0.0003858068 |
| Q3 | 0.0005928581 |
| 95-th percentile | 0.00166034 |
| Maximum | 0.015639344 |
| Range | 0.0156156309 |
| Interquartile range (IQR) | 0.00034004063 |
Descriptive statistics
| Standard deviation | 0.0006931956941 |
|---|---|
| Coefficient of variation (CV) | 1.222133837 |
| Kurtosis | 54.77488203 |
| Mean | 0.0005672011307 |
| Median Absolute Deviation (MAD) | 0.00015247406 |
| Skewness | 5.738463797 |
| Sum | 186.7435987 |
| Variance | 4.805202704e-07 |
| Value | Count | Frequency (%) | |
| 0.00044274333 | 863 | 0.3% | |
| 0.00026626285 | 863 | 0.3% | |
| 0.0002870331 | 863 | 0.3% | |
| 0.00037916107 | 863 | 0.3% | |
| 0.0002569714 | 863 | 0.3% | |
| 0.00045216616 | 863 | 0.3% | |
| 0.00044633303 | 863 | 0.3% | |
| 0.00032764766 | 863 | 0.3% | |
| 0.00031646717 | 863 | 0.3% | |
| 0.00046687486 | 863 | 0.3% | |
| Other values (21447) | 320607 | 97.4% |
| Value | Count | Frequency (%) | |
| 2.37131e-05 | 2 | < 0.1% | |
| 2.7167029e-05 | 1 | < 0.1% | |
| 2.9056831e-05 | 6 | < 0.1% | |
| 3.2550477e-05 | 1 | < 0.1% | |
| 3.9400034e-05 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0.015639344 | 13 | < 0.1% | |
| 0.0103107365 | 259 | 0.1% | |
| 0.00804525 | 2 | < 0.1% | |
| 0.007518653 | 58 | < 0.1% | |
| 0.0070068166 | 2 | < 0.1% |
SFR_MSA
Real number (ℝ≥0)
| Distinct count | 3482 |
|---|---|
| Unique (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9709.09237114905 |
|---|---|
| Minimum | 1.0 |
| Maximum | 153589.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 64 |
| Q1 | 376 |
| median | 1819 |
| Q3 | 9893 |
| 95-th percentile | 51571 |
| Maximum | 153589 |
| Range | 153588 |
| Interquartile range (IQR) | 9517 |
Descriptive statistics
| Standard deviation | 17734.4361 |
|---|---|
| Coefficient of variation (CV) | 1.826580222 |
| Kurtosis | 14.08393759 |
| Mean | 9709.092371 |
| Median Absolute Deviation (MAD) | 1704 |
| Skewness | 3.219428025 |
| Sum | 3196592445 |
| Variance | 314510223.8 |
| Value | Count | Frequency (%) | |
| 1 | 2986 | 0.9% | |
| 50318 | 1726 | 0.5% | |
| 30536 | 863 | 0.3% | |
| 31112 | 863 | 0.3% | |
| 41773 | 863 | 0.3% | |
| 53837 | 863 | 0.3% | |
| 61932 | 863 | 0.3% | |
| 21288 | 863 | 0.3% | |
| 58398 | 863 | 0.3% | |
| 24392 | 863 | 0.3% | |
| Other values (3472) | 317621 | 96.5% |
| Value | Count | Frequency (%) | |
| 1 | 2986 | 0.9% | |
| 2 | 172 | 0.1% | |
| 3 | 95 | < 0.1% | |
| 4 | 122 | < 0.1% | |
| 5 | 138 | < 0.1% |
| Value | Count | Frequency (%) | |
| 153589 | 183 | 0.1% | |
| 148759 | 183 | 0.1% | |
| 140521 | 183 | 0.1% | |
| 132036 | 183 | 0.1% | |
| 126138 | 183 | 0.1% |
RECPI_MSA
Real number (ℝ≥0)
| Distinct count | 21464 |
|---|---|
| Unique (%) | 6.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.263927133687047 |
|---|---|
| Minimum | 2.37131e-05 |
| Maximum | 132.1134 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 2.37131e-05 |
|---|---|
| 5-th percentile | 0.017739179 |
| Q1 | 0.12207872 |
| median | 0.70655054 |
| Q3 | 5.6311555 |
| 95-th percentile | 24.299002 |
| Maximum | 132.1134 |
| Range | 132.1133763 |
| Interquartile range (IQR) | 5.50907678 |
Descriptive statistics
| Standard deviation | 10.39191866 |
|---|---|
| Coefficient of variation (CV) | 1.974176009 |
| Kurtosis | 30.34050581 |
| Mean | 5.263927134 |
| Median Absolute Deviation (MAD) | 0.6749912 |
| Skewness | 4.281911243 |
| Sum | 1733079.578 |
| Variance | 107.9919734 |
| Value | Count | Frequency (%) | |
| 12.0032215 | 863 | 0.3% | |
| 12.930286 | 863 | 0.3% | |
| 13.89656 | 863 | 0.3% | |
| 11.020869 | 863 | 0.3% | |
| 13.122136 | 863 | 0.3% | |
| 13.04385 | 863 | 0.3% | |
| 16.727505 | 863 | 0.3% | |
| 9.818923 | 863 | 0.3% | |
| 12.650854 | 863 | 0.3% | |
| 10.166127 | 863 | 0.3% | |
| Other values (21454) | 320607 | 97.4% |
| Value | Count | Frequency (%) | |
| 2.37131e-05 | 2 | < 0.1% | |
| 2.9056831e-05 | 6 | < 0.1% | |
| 3.2550477e-05 | 1 | < 0.1% | |
| 4.0748477e-05 | 6 | < 0.1% | |
| 4.1634128e-05 | 22 | < 0.1% |
| Value | Count | Frequency (%) | |
| 132.1134 | 145 | < 0.1% | |
| 117.37917 | 145 | < 0.1% | |
| 114.993835 | 145 | < 0.1% | |
| 98.44064 | 145 | < 0.1% | |
| 84.49912 | 145 | < 0.1% |
EQI_state
Real number (ℝ≥0)
| Distinct count | 1363 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.0006146994549785534 |
|---|---|
| Minimum | 7.426358e-05 |
| Maximum | 0.0037453347 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 7.426358e-05 |
|---|---|
| 5-th percentile | 0.00017058598 |
| Q1 | 0.00030582474 |
| median | 0.0004511815 |
| Q3 | 0.0006532353 |
| 95-th percentile | 0.0019132774 |
| Maximum | 0.0037453347 |
| Range | 0.00367107112 |
| Interquartile range (IQR) | 0.00034741056 |
Descriptive statistics
| Standard deviation | 0.0005241844583 |
|---|---|
| Coefficient of variation (CV) | 0.8527491834 |
| Kurtosis | 4.9561615 |
| Mean | 0.000614699455 |
| Median Absolute Deviation (MAD) | 0.00016089047 |
| Skewness | 2.192916245 |
| Sum | 202.3818045 |
| Variance | 2.747693463e-07 |
| Value | Count | Frequency (%) | |
| 0.00031841442 | 918 | 0.3% | |
| 0.00042931232 | 918 | 0.3% | |
| 0.0004341649 | 918 | 0.3% | |
| 0.00030589235 | 918 | 0.3% | |
| 0.000318638 | 918 | 0.3% | |
| 0.00045583185 | 918 | 0.3% | |
| 0.0003402935 | 918 | 0.3% | |
| 0.00046983073 | 918 | 0.3% | |
| 0.00041370557 | 918 | 0.3% | |
| 0.0003624113 | 918 | 0.3% | |
| Other values (1353) | 320057 | 97.2% |
| Value | Count | Frequency (%) | |
| 7.426358e-05 | 103 | < 0.1% | |
| 7.8000994e-05 | 103 | < 0.1% | |
| 7.82489e-05 | 103 | < 0.1% | |
| 8.127372e-05 | 103 | < 0.1% | |
| 8.188262e-05 | 11 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0.0037453347 | 408 | 0.1% | |
| 0.0030291597 | 408 | 0.1% | |
| 0.002947922 | 408 | 0.1% | |
| 0.0027841919 | 707 | 0.2% | |
| 0.002605618 | 707 | 0.2% |
SFR_state
Real number (ℝ≥0)
| Distinct count | 1346 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 53897.785176028214 |
|---|---|
| Minimum | 40.0 |
| Maximum | 330536.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 40 |
|---|---|
| 5-th percentile | 4881 |
| Q1 | 16601 |
| median | 35042 |
| Q3 | 68229 |
| 95-th percentile | 170046 |
| Maximum | 330536 |
| Range | 330496 |
| Interquartile range (IQR) | 51628 |
Descriptive statistics
| Standard deviation | 57447.41025 |
|---|---|
| Coefficient of variation (CV) | 1.065858459 |
| Kurtosis | 5.227866987 |
| Mean | 53897.78518 |
| Median Absolute Deviation (MAD) | 21999 |
| Skewness | 2.153744281 |
| Sum | 1.77451451e+10 |
| Variance | 3300204945 |
| Value | Count | Frequency (%) | |
| 113623 | 1648 | 0.5% | |
| 18675 | 1085 | 0.3% | |
| 114296 | 918 | 0.3% | |
| 55476 | 918 | 0.3% | |
| 134403 | 918 | 0.3% | |
| 111622 | 918 | 0.3% | |
| 60950 | 918 | 0.3% | |
| 111615 | 918 | 0.3% | |
| 76140 | 918 | 0.3% | |
| 128726 | 918 | 0.3% | |
| Other values (1336) | 319160 | 96.9% |
| Value | Count | Frequency (%) | |
| 40 | 1 | < 0.1% | |
| 63 | 1 | < 0.1% | |
| 65 | 1 | < 0.1% | |
| 71 | 1 | < 0.1% | |
| 94 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 330536 | 800 | 0.2% | |
| 313960 | 800 | 0.2% | |
| 295716 | 800 | 0.2% | |
| 287591 | 800 | 0.2% | |
| 276889 | 800 | 0.2% |
RECPI_state
Real number (ℝ≥0)
| Distinct count | 1363 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 34.57783452332148 |
|---|---|
| Minimum | 0.01783298 |
| Maximum | 442.21994000000007 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 2.5 MiB |
Quantile statistics
| Minimum | 0.01783298 |
|---|---|
| 5-th percentile | 1.5803634 |
| Q1 | 6.971263 |
| median | 16.283487 |
| Q3 | 35.750328 |
| 95-th percentile | 93.418846 |
| Maximum | 442.21994 |
| Range | 442.202107 |
| Interquartile range (IQR) | 28.779065 |
Descriptive statistics
| Standard deviation | 58.46623664 |
|---|---|
| Coefficient of variation (CV) | 1.690858825 |
| Kurtosis | 18.81983124 |
| Mean | 34.57783452 |
| Median Absolute Deviation (MAD) | 11.3845894 |
| Skewness | 4.057308626 |
| Sum | 11384302.5 |
| Variance | 3418.300827 |
| Value | Count | Frequency (%) | |
| 34.229965 | 918 | 0.3% | |
| 56.184113 | 918 | 0.3% | |
| 24.070673 | 918 | 0.3% | |
| 30.707523 | 918 | 0.3% | |
| 39.853615 | 918 | 0.3% | |
| 27.86546 | 918 | 0.3% | |
| 32.96178 | 918 | 0.3% | |
| 34.402954 | 918 | 0.3% | |
| 32.540657 | 918 | 0.3% | |
| 37.404045 | 918 | 0.3% | |
| Other values (1353) | 320057 | 97.2% |
| Value | Count | Frequency (%) | |
| 0.01783298 | 11 | < 0.1% | |
| 0.02767606 | 14 | < 0.1% | |
| 0.031676006 | 11 | < 0.1% | |
| 0.03247159 | 11 | < 0.1% | |
| 0.033504028 | 11 | < 0.1% |
| Value | Count | Frequency (%) | |
| 442.21994 | 707 | 0.2% | |
| 424.64432 | 707 | 0.2% | |
| 397.9958 | 707 | 0.2% | |
| 345.09607 | 707 | 0.2% | |
| 308.3075 | 707 | 0.2% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| year | zipcode | EQI_zip | SFR_zip | RECPI_zip | EQI_MSA | SFR_MSA | RECPI_MSA | EQI_state | SFR_state | RECPI_state | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1988 | 1001 | 0.000815 | 48.0 | 0.039108 | 0.001021 | 1235.0 | 1.260888 | 0.001476 | 17558.0 | 25.921940 |
| 1 | 1989 | 1001 | 0.001116 | 44.0 | 0.049100 | 0.001168 | 1049.0 | 1.225384 | 0.001751 | 15343.0 | 26.866861 |
| 2 | 1990 | 1001 | 0.001629 | 45.0 | 0.073317 | 0.001243 | 841.0 | 1.045161 | 0.001857 | 13556.0 | 25.172453 |
| 3 | 1991 | 1001 | 0.000826 | 27.0 | 0.022298 | 0.001375 | 714.0 | 0.981724 | 0.001823 | 12798.0 | 23.330479 |
| 4 | 1992 | 1001 | 0.002216 | 22.0 | 0.048744 | 0.001549 | 760.0 | 1.176877 | 0.002111 | 13289.0 | 28.052156 |
| 5 | 1993 | 1001 | 0.000827 | 27.0 | 0.022334 | 0.001266 | 824.0 | 1.043205 | 0.002057 | 14110.0 | 29.028145 |
| 6 | 1994 | 1001 | 0.004772 | 33.0 | 0.157489 | 0.001394 | 804.0 | 1.121105 | 0.001996 | 14843.0 | 29.624968 |
| 7 | 1995 | 1001 | 0.001065 | 23.0 | 0.024496 | 0.001667 | 817.0 | 1.362325 | 0.002023 | 15180.0 | 30.703022 |
| 8 | 1996 | 1001 | 0.001971 | 29.0 | 0.057166 | 0.001361 | 884.0 | 1.203223 | 0.002326 | 16520.0 | 38.430626 |
| 9 | 1997 | 1001 | 0.000840 | 42.0 | 0.035283 | 0.001233 | 902.0 | 1.112023 | 0.002386 | 17254.0 | 41.174500 |
Last rows
| year | zipcode | EQI_zip | SFR_zip | RECPI_zip | EQI_MSA | SFR_MSA | RECPI_MSA | EQI_state | SFR_state | RECPI_state | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 329227 | 2007 | 99901 | 0.000093 | 27.0 | 0.002516 | 0.000094 | 32.0 | 0.003011 | 0.000126 | 1356.0 | 0.170988 |
| 329228 | 2008 | 99901 | 0.000120 | 27.0 | 0.003237 | 0.000117 | 28.0 | 0.003283 | 0.000120 | 1214.0 | 0.145699 |
| 329229 | 2009 | 99901 | 0.000096 | 21.0 | 0.002015 | 0.000096 | 21.0 | 0.002015 | 0.000101 | 1190.0 | 0.120600 |
| 329230 | 2010 | 99901 | 0.000093 | 30.0 | 0.002782 | 0.000086 | 36.0 | 0.003103 | 0.000112 | 1336.0 | 0.149195 |
| 329231 | 2011 | 99901 | 0.000080 | 35.0 | 0.002795 | 0.000078 | 36.0 | 0.002824 | 0.000111 | 1662.0 | 0.185014 |
| 329232 | 2012 | 99901 | 0.000107 | 30.0 | 0.003195 | 0.000100 | 36.0 | 0.003602 | 0.000123 | 1708.0 | 0.209606 |
| 329233 | 2013 | 99901 | 0.000056 | 26.0 | 0.001469 | 0.000060 | 30.0 | 0.001810 | 0.000088 | 2114.0 | 0.185809 |
| 329234 | 2014 | 99901 | 0.000070 | 32.0 | 0.002242 | 0.000069 | 34.0 | 0.002346 | 0.000088 | 2260.0 | 0.198317 |
| 329235 | 2015 | 99901 | 0.000077 | 50.0 | 0.003867 | 0.000076 | 52.0 | 0.003957 | 0.000093 | 3179.0 | 0.295212 |
| 329236 | 2016 | 99901 | 0.000076 | 47.0 | 0.003571 | 0.000073 | 54.0 | 0.003929 | 0.000082 | 3847.0 | 0.315002 |